package cn.jinshengda.mapper;

import cn.jinshengda.entity.Employee;
import cn.jinshengda.vo.MonthAndCount;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ${author}
 * @since 2022-01-08
 */

@Repository
public interface EmployeeMapper extends BaseMapper<Employee> {
    Integer queryCount(@Param("education") String education, @Param("workTime") String workTime);

    Integer queryByDepartmentCount(Integer departmentId);

    //查询每月新员工信息
    List<Employee> queryByMonthEmployee(@Param("sex") String sex,@Param("startMonth") String startMonth,@Param("endMonth") String endMonth);
    //查询每月新员工个数
    List<MonthAndCount> queryByMonthCount(@Param("sex") String sex, @Param("startMonth") String startMonth, @Param("endMonth") String endMonth);

}
